SQL Server Megaservers: Scalability, Availability, Manageability
نویسنده
چکیده
Microsoft® SQL ServerTM has evolved to support huge databases and applications, including multiterabyte databases used by millions of people. SQL Server achieves this scalability by supporting scale up on symmetric multiprocessor (SMP) systems, allowing users to add processors, memory, disks and networking to build a large single node, as well as scale out on multinode clusters, allowing a huge database to be partitioned into a cluster of servers, each server storing part of the whole database, and each doing a part of the work, while the database remains accessible as a single entity. Using scale out, SQL Server 2000 achieved the top Transaction Processing Council Benchmark C (TPC-C) performance results of any database system on any platform.
منابع مشابه
HP Integrity Superdome 2: The ultimate mission-critical platform- Technical white paper
Introduction .................................................................................................................................................................................... 2 Product family ................................................................................................................................................................................ 2 Perform...
متن کاملSupporting Security and Consistency for Cloud Database
Typical Cloud database services guarantee high availability and scalability, but they rise many concerns about data confidentiality. Combining encryption with SQL operations is a promising approach although it is characterized by many open issues. Existing proposals, which are based on some trusted intermediate server, limit availability and scalability of original cloud database services. We p...
متن کاملActive connection management in Internet services
We propose a new connection management architecture for clustered Internet services called Active Connection Management (ACM) to improve the availability, quality of service, and manageability of Internet services. ACM extends the API of load-balancing switches to include application-level primitives. These primitives enable Internet services to manage loadbalancing switches dynamically to cont...
متن کاملComparisons Between MongoDB and MS-SQL Databases on the TWC Website
Owing to the huge amount of data in websites to be analysed, web innovative services are required to support them with high scalability and availability. The main reason of using NoSQL databases is for considering the huge amount of data and expressing large-scale distributed computations using Map-Reduce techniques. To enhance the service quality of customers and solve the problems of the huge...
متن کاملOptimizing Storage Performance, Provisioning, and Manageability for Microsoft SQL Server
Microsoft® SQL ServerTM has become very popular as a database environment driving a broad range of mid-level business applications, ranging from Customer Relationship Management (CRM) to eCommerce and from Enterprise Resource Planning (ERP) to supply chain integration. The combination of affordability, performance, ease of deployment, and sophisticated analytical features has led to a significa...
متن کامل